/*
 * To change this template, choose Tools | Templates
 * and open the template in the editor.
 */
package handlers;

import database.*;
import java.sql.*;
import java.util.ArrayList;
import model.*;

/**
 *
 * @author Allan
 */
public abstract class CustomerHandler
{
    public static ArrayList<Customer> getCustomer() throws ClassNotFoundException, SQLException
    {
        Database db = new Database();
        db.connectToDB();
        ResultSet rs = db.query("CALL ");
        
        ArrayList<Customer> toReturn = new ArrayList();
        
//        toReturn.add(new ProductGroup(0, "Alle varer"));
//        
//        if(rs.isBeforeFirst())
//        {
//            while(rs.next())
//            {
//                toReturn.add(new ProductGroup(rs.getInt("varegruppeID"), rs.getString("varegruppeNavn")));
//            }
//        }
        
        db.closeDB();
        return toReturn;
    }
}
